home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Tech Arsenal 1
/
Tech Arsenal (Arsenal Computer).ISO
/
tek-04
/
shazam11.zip
/
DEMOQ2.DEF
< prev
next >
Wrap
Text File
|
1991-11-04
|
46KB
|
1,316 lines
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Model Quattro Pro menu structure
@@ Note: Compiler cannot handle the MenuBar statement!
@@ Divide & Conquer:
@@ demoQ3.def = [File..Database]
@@ demoQ4.def = [Tools..Window]
@@ FYI You CAN generate the code from this definition file, but
@@ you will encounter the following errors when compiling:
@@ TPC - Error 129: ENDIF directive missing.
@@ IDE - Error 124: statement part too large
@@ Also, the compiler may hang...This is due to the fact that
@@ no TP "statement" may be larger than 24 kilobytes.
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
[APPLICATION] ;;Quattro Pro Menu Model
@@ =================================================================
@@ MENU
@@ =================================================================
[SUBMENU]File ;;file operations
new ;;open a new blank spreadsheet window
open ;;load a file into a new spreadsheet window
retrieve ;;load a spreadsheet into the current window
[NEWLINE]
save ctrl-s ;;save the current spreadsheet on disk
'save As' ;;save the current spreadsheet under a new name
close ;;close the current spreadsheet window
'c~l~ose all' ;;close all open windows
erase ;;erase the contents of the current worksheet
[NEWLINE]
directory ;;lets you set a temporary data directory
>[SUBMENU]workspace ;;save or load a setup of windows and files
save ;;save the current arrangement of windows and files
restore ;;load a saved workspace
<
>[SUBMENU]utilities ;;access DOS, the file manager, or SQZ! settings
'DOS shell' ;;execute DOS commands
'file manager' ;;open a file manager window
>[SUBMENU]SQZ! ;;set SQZ! file compression options
>[SUBMENU]'remove blanks' ;;remove empty cells before saving
no ;;remove empty cells before saving
yes ;;remove empty cells before saving
<
>[SUBMENU]'storage of values' ;;stores exact values, approximate values, or formulas only
exact ;;stores exact values, approximate values, or formulas only
approximate ;;stores exact values, approximate values, or formulas only
remove ;;stores exact values, approximate values, or formulas only
<
>[SUBMENU]version ;;save as SQZ! Plus or SQZ! file
'1 - SQZ!' ;;save as SQZ! Plus or SQZ! file
'2 - SQZ! Plus' ;;save as SQZ! Plus or SQZ! file
<
quit kbF10 ;;return to worksheet
<
<
E~x~it ctrl-x cmquit ;;close all windows & exit to DOS
@@ =================================================================
@@ MENU
@@ =================================================================
[SUBMENU]Edit ;;copy, move, insert, delete data; block names; search & replace
copy ctrl-c ;;copy a block of data
move ctrl-m ;;move a block of data
'erase block' ctrl-e ;;erase a block of data
undo alt-f5 ;;undo the last operation
[NEWLINE]
>[SUBMENU]insert ctrl-i ;;insert one or more rows/columns
rows ;;insert row(s) above the current row
columns ;;insert the column(s) to the left of the current one
<
>[SUBMENU]delete ;;delete one or more rows/columns
rows ;;delete all rows in the selected block
columns ;;delete all columns in the selected block
<
[NEWLINE]
>[SUBMENU]names ;;assign, delete, or create a table of block names
create ;;assign a name to a block
delete ;;remove an assigned name from a block
>[SUBMENU]labels ;;create block names using labels
right ;;assign names to cells to the right of labels
down ;;assign names to cells under labels
left ;;assign names to cells to the left of labels
up ;;assign names to cells above labels
<
reset ;;delete all block names
'make table' ;;create table of block names in the spreadsheet
<
fill ;;fill a block with numbers
values ;;convert formulas in a block to their resulting values
transpose ;;copy a block, switching columns with rows
>[SUBMENU]'search & replace' ;;search for or replace values in a block
block ;;cells to be searched
'search string' ;;string to search for
'replace string' ;;string to replace search string
[NEWLINE]
>[SUBMENU]'look in' ;;search through formulas, resulting values, or for a condition
formula ;;examine each formula for the search string
value ;;examine each formulas result for the search string
condition ;;examine each formula result to see if it matches the condition
<
>[SUBMENU]direction ;;search row by row or column by column
row ;;search down each row, one at a time
column ;;search down each column, one at a time
<
>[SUBMENU]match ;;search for string as whole entry or part
part ;;ex: A2 is found in @SUM(A2..A3) and in @SUM(AA22..AA33)
whole ;;ex: A2 is found in @SUM(A2..A3) but not in @SUM(AA22..AA33)
<
>[SUBMENU]'case sensitive' ;;distinguish between upper- and lower-case characters or not
'any case' ;;compare upper-case same as lower
'exact case' ;;exact letter-case match only
<
'options reset' ;;reset Search String, Replace String, and Options
[NEWLINE]
next ctrl-n ;;begin searching forward
previous ctrl-p ;;begin search in reverse order
quit kbF10 ;;return to the spreadsheet
<
@@ =================================================================
@@ MENU
@@ =================================================================
[SUBMENU]Style ;;block formats, alignment, protection, column info, publishing
>[SUBMENU]alignment ctrl-a ;;Change alignment (left, right, center) of a block of cells
general ;;Labels left, numbers right
left ;;Numbers and labels flush with the left edge of the cell
right ;;Numbers and labels flush with the right edge of the cell
center ;;Numbers and labels centered within the cell width
<
>[SUBMENU]'numeric format' ctrl-f ;;Change display format of numbers or dates in a block
fixed ;;Fixed number of decimal places
scientific ;;Exponential format
currency ;;Currency format
, ;;Thousand separator; negative values in parenthesis
general ;;Standard format
+/- ;;Horizontal bar graph format (+++ or ---)
percent ;;Percent format
>[SUBMENU]date ;;Date and time formats
'1-(~D~D-MMM-YY)' ;;Day-Month-Year
'2-(DD-~M~MM)' ;;Day-Month
'3-(MMM-~Y~Y)' ;;Month-Year
'4-(Long intl.)' ;;Use the current long international date format
'5-(Short intl.)' ;;Use the current short international date format
>[SUBMENU]time ;;Time formats
'1-(HH:MM:~S~S AM/PM)' ;;Hour:Minute:Second AM/PM
'2-(HH:~M~M AM/PM)' ;;Hour:Minute AM/PM
'3-(Long intl.)' ;;Use the current long international time format
'4-(Short intl.)' ;;Use the current short international time format
<
<
text ;;Display formula instead of values
hidden ;;Supress cell display
reset ;;Use the global cell display formula
<
>[SUBMENU]protection ;;Protect or unprotect a block of cells from changes
protect ;;Protect a block if global protection is enabled
unprotect ;;Remove protection from a block
<
[NEWLINE]
'column width' ctrl-w ;;Alter the width of the current column
'reset width' ;;Set width of the current column to the default width
>[SUBMENU]'hide column' ;;Conceal columns from display/Return hidden columns
hide ;;Hide columns from view without losing data
expose ;;Expose hidden columns
<
>[SUBMENU]'block widths' ;;Adjust the width of columns in a block
'set width' ;;Specify the width of columns in a block
'reset width' ;;Return columns to the default width
'auto width' ;;Adjust the width of columns according to data length
<
'line drawing' ;;Draw lines in or around a block of cells
>[SUBMENU]shading ;;Add or remove shading for a block of cells
none ;;No shading
grey ;;Grey shading behind data in a block of cells
black ;;Black shading behind data in a block of cells
<
>[SUBMENU]fonts ;;Change the font a block of cells will be printed with
'1 font 1' ;;Use font 1 for the block
'2 font 2' ;;Use font 2 for the block
'3 font 3' ;;Use font 3 for the block
'4 font 4' ;;Use font 4 for the block
'5 font 5' ;;Use font 5 for the block
'6 font 6' ;;Use font 6 for the block
'7 font 7' ;;Use font 7 for the block
'8 font 8' ;;Use font 8 for the block
>[SUBMENU]'edit fonts' ;;Modify existing fonts
'1 font 1' ;;Change font 1's typeface, point size, style or color
'2 font 2' ;;Change font 2's typeface, point size, style or color
'3 font 3' ;;Change font 3's typeface, point size, style or color
'4 font 4' ;;Change font 4's typeface, point size, style or color
'5 font 5' ;;Change font 5's typeface, point size, style or color
'6 font 6' ;;Change font 6's typeface, point size, style or color
'7 font 7' ;;Change font 7's typeface, point size, style or color
'8 font 8' ;;Change font 8's typeface, point size, style or color
quit kbF10 ;;Return to spreadsheet
<
reset ;;Reset all fonts to their default
<
'insert break' ;;Put a page break in the current cell
@@ =================================================================
@@ MENU
@@ =================================================================
[SUBMENU]Graph ;;display/print business graphics from spreadsheet data
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 1
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]'graph type' ;;Type of graph (bar, line, pie, etc.)
Line ;;Line graph
Bar ;;Bar graph
XY ;;XY graph, also called a scatter graph
'Stacked Bar' ;;Stacked bar graph, also called a cumulative bar
Pie ;;Pie graph
Area ;;Area graph
'Rotated Bar' ;;Rotated bar, also called a horizontal bar
Column ;;Column graph, a rectangular percentage pie
High-Low ;;Hi-low-open-close graph
Text ;;Text only graph
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 1
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]series ;;Select blocks of data to graph
'1st Series' ;;First set of values to plot on graph
'2nd Series' ;;Second set of values to plot on graph
'3rd Series' ;;Third set of values to plot on graph
'4th Series' ;;Fourth set of values to plot on graph
'5th Series' ;;Fifth set of values to plot on graph
'6th Series' ;;Sixth set of values to plot on graph
'X-Axis Series' ;;Set of values to label or plot on or label the X-axis
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Group ;;Block of data to be divided into series
rows ;;Assign each column of values in the block to a series
columns ;;Assign each row of values in the block to a series
<
Quit kbEsc ;;Return to the graph menu
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 1
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]text ;;Set text for titles and legends
'1st Line' ;;Text for 1st line of the title
'2nd Line' ;;Text for 1st line of the title
X-Title ;;Text for the X-axis title
Y-Title ;;Text for the Y-axis title
'Secondary Y-Axis' ;;Text for the secondary Y-axis title
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Legends ;;Create or reposition the graph legend defining each series
'1st Series' ;;Text to define this series in the legend
'2nd Series' ;;Text to define this series in the legend
'3rd Series' ;;Text to define this series in the legend
'4th Series' ;;Text to define this series in the legend
'5th Series' ;;Text to define this series in the legend
'6th Series' ;;Text to define this series in the legend
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Position ;;Change the position of legend or remove legend altogether
Bottom ;;Display legend at bottom
Right ;;Display legend to right of graph
None ;;Don't display a legend
<
Quit kbEsc ;;Return to Text menu
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Font
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]'1st Line' ;;The typeface and size for the first title line
Typeface ;;Change the typeface
'Point Size' ;;Change the point size
Style ;;Change attributes such as Bold or Underlined
Color ;;Change the color
Quit kbEsc ;;Return to previous menu
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]2nd Line
Typeface ;;Change the typeface
'Point Size' ;;Change the point size
Style ;;Change attributes such as Bold or Underlined
Color ;;Change the color
Quit kbEsc ;;Return to previous menu
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]X-Title ;;The typeface and size for the X-axis label
Typeface ;;Change the typeface
'Point Size' ;;Change the point size
Style ;;Change attributes such as Bold or Underlined
Color ;;Change the color
Quit kbEsc ;;Return to previous menu
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Y-Title ;;The typeface and size for the Y-axis label
Typeface ;;Change the typeface
'Point Size' ;;Change the point size
Style ;;Change attributes such as Bold or Underlined
Color ;;Change the color
Quit kbEsc ;;Return to previous menu
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Legends ;;The typeface and size for the legends
Typeface ;;Change the typeface
'Point Size' ;;Change the point size
Style ;;Change attributes such as Bold or Underlined
Color ;;Change the color
Quit kbEsc ;;Return to previous menu
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]'Data & Tick Labels' ;;The typeface and size for data and tick labels
Typeface ;;Change the typeface
'Point Size' ;;Change the point size
Style ;;Change attributes such as Bold or Underlined
Color ;;Change the color
Quit kbEsc ;;Return to previous menu
<
Quit ;;Return to spreadsheet
<
Quit ;;Return to spreadsheet
<
[NEWLINE]
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 1
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]'customize series' ;;Change display of individual data series
Colors ;;
'Fill Patterns'
'Markers & Lines'
'Bar Width'
[NEWLINE]
'Interior Labels'
'Override Type'
Y-Axis
Pies
Update
Reset
Quit ;;Return to spreadsheet
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 1
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]x-axis ;;Change display and/or scaling of the X-axis
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Scale
Automatic
Manual
<
Low
High
Increment
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Format of Ticks
Fixed
Scientific
Currency
,
General
+/-
Percent
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Date
'1-(DD-MMM-YY)'
'2-(DD-MMM)'
'3-(MMM-YY)'
'4-(Long intl.)'
'5-(Short intl.)'
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 4
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Time
'1-(HH:MM:SS AM/PM)'
'2-(HH:MM AM/PM)'
'3-(Long intl.)'
'4-(Short intl.)'
<
<
Text
Hidden
<
'No. of Minor Ticks'
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Alternate Ticks
No
Yes
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Display Scaling
Yes
No
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Mode
Normal
Log
<
Quit ;;Return to spreadsheet
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 1
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]y-axis ;;Change display and/or scaling of the Y-axis
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Scale
Automatic
Manual
<
Low
High
Increment
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Format of Ticks
Fixed
Scientific
Currency
,
General
+/-
Percent
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Date
'1-(DD-MMM-YY)'
'2-(DD-MMM)'
'3-(MMM-YY)'
'4-(Long intl.)'
'5-(Short intl.)'
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 4
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Time
'1-(HH:MM:SS AM/PM)'
'2-(HH:MM AM/PM)'
'3-(Long intl.)'
'4-(Short intl.)'
<
<
Text
Hidden
<
'No. of Minor Ticks'
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Display Scaling
Yes
No
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Mode
Normal
Log
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]2nd Y-Axis
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Scale
Automatic
Manual
<
Low
High
Increment
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Format of Ticks
Fixed
Scientific
Currency
,
General
+/-
Percent
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 4
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Date
'1-(DD-MMM-YY)'
'2-(DD-MMM)'
'3-(MMM-YY)'
'4-(Long intl.)'
'5-(Short intl.)'
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 5
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ >[SUBMENU]Time
@@ '1-(HH:MM:SS AM/PM)'
@@ '2-(HH:MM AM/PM)'
@@ '3-(Long intl.)'
@@ '4-(Short intl.)'
@@ <
<
Text
Hidden
<
'No. of Minor Ticks'
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Display Scaling
Yes
No
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Mode
Normal
Log
<
Quit ;;Return to spreadsheet
[NEWLINE]
<
Quit ;;Return to spreadsheet
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 1
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]overall ;;Customize overall graph appearance
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Grid
Horizontal
Vertical
Both
Clear
[NEWLINE]
Grid Color
Line Style
Fill Color
Quit ;;Return to spreadsheet
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Outlines
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Titles
Box
Double-line
Thick-line
Shadow
3D
Rnd Rectangle
None
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Legend
Box
Double-line
Thick-line
Shadow
3D
Rnd Rectangle
None
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 3
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Graph
Box
Double-line
Thick-line
Shadow
3D
Rnd Rectangle
None
<
Quit ;;Return to spreadsheet
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Background Color
Black
Blue
Green
Cyan
Red
Magenta
Brown
White
Gray
Light Blue
Light Green
Light Cyan
Light Red
Light Magenta
Yellow
Bright White
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Three-D
Yes
No
<
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 2
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]Color/B&W
Color
B&W
<
<
[NEWLINE]
insert ;;Insert a named graph in the worksheet
hide ;;Remove an inserted graph from the spreadsheet
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
@@ Level 1
@@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>[SUBMENU]name ;;Create, use, or delete named graphs
Display
Create
Erase
Reset
Slide
<
view f10 ;;View the current graph
'fast graph' ctrl-g ;;Draw a graph using a block
annotate ;;Activate the Graph Annotator for the current graph
quit ;;Return to the spreadsheet
@@ =================================================================
@@ MENU
@@ =================================================================
[SUBMENU]Print ;;print a spreadsheet or graph
Block ;;The block of the spreadsheet to print
>[SUBMENU]Headings ;;Row and Column headings to print on each page
'Left Heading'
'Top Heading'
<
[NEWLINE]
>[SUBMENU]Destination ;;Specify printing to printer, file, or screen for Spreadsheet
>[SUBMENU]'Draft Mode Printing'
Printer
File
<
>[SUBMENU]'Final Quality Printing'
'Binary File'
'Graphics Printer'
'Screen Preview'
<
<
>[SUBMENU]Layout ;;Define layout for spreadsheet printing
Header
Footer
[NEWLINE]
>[SUBMENU]'Break Pages'
Yes
No
<
>[SUBMENU]Margins
'Page Length'
Left
Top
Right
Bottom
[NEWLINE]
Quit ;;Return to spreadsheet
<
>[SUBMENU]Dimensions
Lines/Characters
Inches
Centimeters
<
>[SUBMENU]Orientation
Portrait
Landscape
<
'Setup String'
[NEWLINE]
>[SUBMENU]Reset
All
'Print Block'
Headings
Layout
<
Update
Quit ;;Return to spreadsheet
<
>[SUBMENU]Format ;;Print spreadsheet as displayed or as list of cells info
'As Displayed'
Cell-Formulas
<
[NEWLINE]
>[SUBMENU]'Adjust Printer' ;;Advance paper in printer, set to top of form
'Skip Line'
'Form Feed'
Align
<
'Spreadsheet Print' ;;Print the data in the print block
>[SUBMENU]'Graph Print' ;;Print graphs
>[SUBMENU]Destination
File
'Graph Printer'
'Screen Preview'
<
>[SUBMENU]Layout
'Left Edge'
'Top Edge'
Height
Width
[NEWLINE]
>[SUBMENU]Dimensions
Inches
Centimeters
<
>[SUBMENU]Orientation
Portrait
Landscape
<
>[SUBMENU]'4:3 Aspect'
Yes
No
<
[NEWLINE]
Reset
Update
Quit ;;Return to spreadsheet
<
Go
>[SUBMENU]'Write Graph File'
'EPS File'
'PIC File'
Quit ;;Return to spreadsheet
<
Name
Quit ;;Return to spreadsheet
<
Quit ;;Return to spreadsheet
@@ =================================================================
@@ MENU
@@ =================================================================
[SUBMENU]Database ;;work with spreadsheet data in database format
>[SUBMENU]Sort ;;Sort rows in a block using data in one or more columns
Block
1st Key
2nd Key
3rd Key
4th Key
5th Key
[NEWLINE]
Go
Reset
>[SUBMENU]Sort Rules
>[SUBMENU]Numbers before Labels
No
Yes
<
>[SUBMENU]Label Order
Dictionary
ASCII
<
Quit ;;Return to spreadsheet
<
Quit ;;Return to spreadsheet
<
>[SUBMENU]Query ;;Use criteria to search for, delete or copy records
Block
Criteria Table
Output Block
[NEWLINE]
Assign Names
Locate
Extract
Unique
Delete
[NEWLINE]
Reset
Quit ;;Return to spreadsheet
<
Restrict Input ;;Restrict selector to only unprotected cells in a block
>[SUBMENU]Data Entry ;;Select how information is entered into a cell
General
Labels Only
Dates Only
<
@@ =================================================================
@@ MENU
@@ =================================================================
[SUBMENU]Tools ;;advanced tools such as macros, text import, and statistics
>[SUBMENU]Macro Alt-F2 ;;Create, execute, and debug macros; activate Transcript utility
Record
Paste
Instant Replay
>[SUBMENU]Macro Recording
Logical
Keystroke
<
[NEWLINE]
Transcript
Clear Breakpoints
>[SUBMENU]Debugger
Yes
No
<
>[SUBMENU]Name
Create
Delete
<
>[SUBMENU]Library
Yes
No
<
[NEWLINE]
Execute
<
Reformat ;;Reformat labels in a column to the specified column width
[NEWLINE]
>[SUBMENU]Import ;;Import ASCII or comma delimited data
ASCII Text File
Comma & "" Delimited File
Only Commas
<
>[SUBMENU]Combine ;;Combine information from two files
>[SUBMENU]Copy
File
Block
<
>[SUBMENU]Add
File
Block
<
>[SUBMENU]Subtract
File
Block
<
<
>[SUBMENU]Xtract ;;Extract values from this file to a new file
Formulas
Values
<
>[SUBMENU]Update Links ;;Open, refresh, change, or delete links to other spreadsheets
Open
Refresh
Change
Delete
<
[NEWLINE]
>[SUBMENU]Advanced Math ;;Regression analysis, matrix arithmetic, and linear programming
>[SUBMENU]Regression
Independent
Dependent
Output
>[SUBMENU]Y Intercept
Compute
Zero
<
[NEWLINE]
Go
Reset
Quit ;;Return to spreadsheet
<
Invert
Multiply
>[SUBMENU]Optimization
Linear constraint coefficients
Inequality/equality relations
Constant constraint terms
Bounds for variables
Formula constraints
Objective function
>[SUBMENU]Extremum
Smallest
Largest
<
[NEWLINE]
Solution
Variables
Dual values
Additional dual values
[NEWLINE]
Go
Reset
Quit ;;Return to spreadsheet
<
<
>[SUBMENU]Parse ;;Divide long labels into separate columns or fields
Input
Output
[NEWLINE]
Create
Edit
Go
[NEWLINE]
Reset
Quit ;;Return to spreadsheet
<
>[SUBMENU]What-If ;;Vary the values of one or two cells and create a table
1 Variable
2 Variables
Reset
Quit ;;Return to spreadsheet
<
Frequency ;;Count the frequency of values within a given range
@@ =================================================================
@@ MENU
@@ =================================================================
[SUBMENU]Options ;;set or change system and spreadsheet defaults
>[SUBMENU]Hardware ;;Specify screen and printer information
>[SUBMENU]Screen
>[SUBMENU]Screen Type
Autodetect Driver
B. CGA
C. MCGA
D. 256K EGA
E. 64K EGA
F. Monochrome EGA
G. IBM 8514/A
H. Hercules
I. AT&T-Compaq 400 Line
J. VGA
K. IBM 3270 PC
L. MDA (No Graphics)
<
>[SUBMENU]Resolution
<
Aspect Ratio
>[SUBMENU]CGA Snow Suppression
No
Yes
<
Quit ;;Return to spreadsheet
<
>[SUBMENU]Printers
>[SUBMENU]1st Printer
<
>[SUBMENU]2nd Printer
<
>[SUBMENU]Default Printer
<
[NEWLINE]
Plotter Speed
>[SUBMENU]Fonts
>[SUBMENU]LaserJet Fonts
Left Cartridge
Right Cartridge
<
>[SUBMENU]Autoscale Fonts
Yes
No
<
<
>[SUBMENU]Auto LF
No
Yes
<
>[SUBMENU]Single Sheet
No
Yes
<
Quit ;;Return to spreadsheet
<
@@ Normal Memory─────204240─
@@ EMS───────────────────NA─
@@ Coprocessor───────────No─
<
>[SUBMENU]Colors ;;Specify screen colors for Quattro
>[SUBMENU]Menu
Frame
Banner
Text
Key Letter
Highlight
Settings
Explanation
Drop Shadow
Mouse Palette
'Fill Characters - Shadow'
Quit ;;Return to spreadsheet
<
>[SUBMENU]Desktop
@@ Colors───────────────
Status
Highlight-Status
Errors
Background
'Fill Characters - Desktop'
Quit ;;Return to spreadsheet
<
>[SUBMENU]Spreadsheet
Frame
Banner
Cells
Borders
Titles
Highlight
Graph Frames
Input Line
Unprotected
Labels
Shading
Drawn Lines
Quit ;;Return to spreadsheet
<
>[SUBMENU]Conditional
>[SUBMENU]On/Off
Enable
Disable
<
ERR
Smallest Normal Value
Greatest Normal Value
Below Normal Color
Normal Cell Color
Above Normal Color
Quit ;;Return to spreadsheet
<
>[SUBMENU]Help
Frame
Banner
Text
Keywords
Highlight
Quit ;;Return to spreadsheet
<
>[SUBMENU]File Manager
Frame
Banner
Text
Active cursor
Inactive cursor
Marked
Cut
Copy
Quit ;;Return to spreadsheet
<
>[SUBMENU]Palettes
Color
Monochrome
Black & White
Quit ;;Return to spreadsheet
<
Quit ;;Return to spreadsheet
<
>[SUBMENU]International ;;Set international standards for currency, date, and time
Currency
>[SUBMENU]Punctuation
A. '1,234.56 (a1,a2)'
B. '1.234,56 (a1.a2)'
C. '1,234.56 (a1;a2)'
D. '1.234,56 (a1;a2)'
E. '1 234.56 (a1,a2)'
F. '1 234,56 (a1.a2)'
G. '1 234.56 (a1;a2)'
H. '1 234,56 (a1;a2)'
<
>[SUBMENU]Date
A. 'MM/DD/YY (MM/DD)'
B. 'DD/MM/YY (DD/MM)'
C. 'DD.MM.YY (DD.MM)'
D. 'YY-MM-DD (MM-DD)'
<
>[SUBMENU]Time
A. HH:MM:SS (HH:MM)
B. HH.MM.SS (HH.MM)
C. HH,MM,SS (HH,MM)
D. HHhMMmSSs (HHhMMm)
<
Quit ;;Return to spreadsheet
<
>[SUBMENU]Display Mode ;;Set display mode
<
>[SUBMENU]Startup ;;Set startup and default options for Quattro
Directory
Autoload File
Startup Macro
File Extension
>[SUBMENU]Beep
No
Yes
<
>[SUBMENU]Menu Tree
<
Edit Menus
Quit ;;Return to spreadsheet
<
>[SUBMENU]Mouse Palette ;;Redefine mouse palette
>[SUBMENU]1st Button
Text
Macro
Quit ;;Return to spreadsheet
<
>[SUBMENU]2nd Button
Text
Macro
Quit ;;Return to spreadsheet
<
>[SUBMENU]3rd Button
Text
Macro
Quit ;;Return to spreadsheet
<
>[SUBMENU]4th Button
Text
Macro
Quit ;;Return to spreadsheet
<
>[SUBMENU]5th Button
Text
Macro
Quit ;;Return to spreadsheet
<
>[SUBMENU]6th Button
Text
Macro
Quit ;;Return to spreadsheet
<
>[SUBMENU]7th Button
Text
Macro
Quit ;;Return to spreadsheet
<
Quit ;;Return to spreadsheet
<
>[SUBMENU]Graphics Quality ;;Use Draft or Final quality graphics
Final
Draft
<
>[SUBMENU]Other ;;Set Undo, Macro, EMS, and Clock Options
>[SUBMENU]Undo
Enable
Disable
<
>[SUBMENU]Macro ;;suppress redraw during macros
Both
Panel
Window
None
<
>[SUBMENU]Expanded Memory
Both
Spreadsheet Data
Format
None
<
>[SUBMENU]Clock
Standard
International
None
<
>[SUBMENU]Paradox
>[SUBMENU]Network Type
Disabled
Novell
3Com
IBM-PC LAN
Other
Torus 1.4
Starlan
Banyan
<
Directory
Retries
Quit ;;Return to spreadsheet
<
<
[NEWLINE]
Update ;;Save all current default settings
[NEWLINE]
>[SUBMENU]Formats ;;Set global display format, label alignment, col widths...
>[SUBMENU]Numeric Format
Fixed
Scientific
Currency
,
General
+/-
Percent
>[SUBMENU]Date
1-(DD-MMM-YY)
2-(DD-MMM)
3-(MMM-YY)
4-(Long intl.)
5-(Short intl.)
>[SUBMENU]Time
1-(HH:MM:SS AM/PM)
2-(HH:MM AM/PM)
3-(Long intl.)
4-(Short intl.)
<
<
Text
Hidden
<
>[SUBMENU]Align Labels
Left
Right
Center
<
>[SUBMENU]Hide Zeros
No
Yes
<
Global Width
Quit ;;Return to spreadsheet
<
>[SUBMENU]Recalculation ;;Set recalculation options
>[SUBMENU]Mode Background
Automatic
Manual
Background
<
>[SUBMENU]Order Natural
Natural
Column-wise
Row-wise
<
Iteration 1
[NEWLINE]
@@ Circular Cell ??
Quit ;;Return to spreadsheet
<
>[SUBMENU]Protection ;;Enable or disable global spreadsheet protection
Enable
Disable
<
Quit ;;Return to spreadsheet
@@ =================================================================
@@ MENU
@@ =================================================================
[SUBMENU]Window ;;control size of windows, select windows, tile or stack windows
Zoom Alt-F6 ;;Maximize or minimize the top window
Tile Ctrl-T ;;Display all open windows on screen at once
Stack ;;Layer open windows on screen, overlapping each other
Move/Size Ctrl-R ;;Move or resize current window
[NEWLINE]
>[SUBMENU]Options ;;Display options for current window
Horizontal
Vertical
Sync
Unsync
Clear
[NEWLINE]
>[SUBMENU]'Locked Titles'
Horizontal
Vertical
Both
Clear
<
>[SUBMENU]'Row & Col Borders'
Display
Hide
<
>[SUBMENU]'Map View'
Yes
No
<
<
[NEWLINE]
Pick Alt-0 ;;Display list of open windows to choose from